﻿<%@ Application Language="C#" %>
<%@ Import Namespace="System.Timers" %>
<%@ Import Namespace="nspEmail.Lables" %>

<script RunAt="server">

    void Application_Start(object sender, EventArgs e)
    {
        
        // 在应用程序启动时运行的代码
        System.Timers.Timer MT = new System.Timers.Timer();
        
        MT.Enabled = true;
        MT.Interval = 1000;
        //    MT.AutoReset = false;
        MT.Elapsed += new System.Timers.ElapsedEventHandler(MTimedEvent);

    }
    void MTimedEvent(object source, System.Timers.ElapsedEventArgs e)
    {
        //开始工作
        StartWork();
    }
    void StartWork()
    {
        string CurrTime = System.DateTime.Now.ToString("T");
        string EmailStartTime = "18:30:10";
        
        if (CurrTime == EmailStartTime)
        {
            string sql = "select a.Type as TypeID,a.UserID,b.Email as Email,c.LoginName  from U_SubscriptionNews a inner join U_SubscriptionEmail b on a.UserID=b.UserID inner join U_UserInfo c on b.UserID=c.UserID";
            new EmailTempinc().GetTemplate("us_SubScriptionNews", sql);
            string sql2 = "select a.Email,a.UserID,a.ID as TypeID,c.LoginName  from U_SubscriptionEmail as a inner join U_UserInfo c on a.UserID=c.UserID where a.UserID in(select UserID from U_SubscriptionProduct  group by UserID)";
            new EmailTempinc().GetTemplate("us_SubscriptionProduct", sql2); 
        } 
    }


    void Application_End(object sender, EventArgs e)
    {
        //  在应用程序关闭时运行的代码

    }

    void Application_Error(object sender, EventArgs e)
    {
        // 在出现未处理的错误时运行的代码

    }

    void Session_Start(object sender, EventArgs e)
    {
        // 在新会话启动时运行的代码

    }

    void Session_End(object sender, EventArgs e)
    {
        // 在会话结束时运行的代码。 
        // 注意: 只有在 Web.config 文件中的 sessionstate 模式设置为
        // InProc 时，才会引发 Session_End 事件。如果会话模式设置为 StateServer 
        // 或 SQLServer，则不会引发该事件。

    }
       
</script>

